home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
vlastprobe.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
474b
|
19 lines
CREATE OR REPLACE VIEW vlastprobe AS
SELECT
BUS.BUS_ID, FAREBOX.FAREBOX_ID, PRO.CONVERSION_NUM,
OPE.USER_ID, OPE.FAREBOX_GLID
FROM
BUS BUS,
FAREBOX FAREBOX,
PROBEHIST PRO,
PROBE_CONTEXT PROC,
OPERATOR_CONTEXT OPE
WHERE
( BUS.GLID=FAREBOX.LOCATION ) AND
( FAREBOX.GLID=PRO.FAREBOX_GLID ) AND
( PRO.CONVERSION_NUM=PROC.CONVERSION_NUM ) AND
( PRO.PDATE=PROC.PROBE_DATE ) AND
( PROC.PROBE_CONTEXT_ID=OPE.PROBE_CONTEXT_ID )